﻿using System;
using System.Collections.Generic;
using System.Text;

namespace hedefgrup.reports.common.SSRD
{
    public class Report_SSRD_Verbatim : Report_Verbatim
    {
        protected override void SetCriteriaList()
        {
            Criterias.Add(new Criteria_EndMonth() { Context = Context });
            Criterias.Add(new Criteria_SSRD_Organization() { Context = Context });
        }

        protected override string GetSelectFields()
        {
            return
                "SELECT IID, YIL, AY, " +
                "[SATIŞ TARİHİ] = CONVERT(VARCHAR, YIL) + SUBSTRING('0' + CONVERT(VARCHAR, AY), LEN('0' + CONVERT(VARCHAR, AY) - 2), 2), " +
                base.DealerColumn + ", [YETKİLİ SERVİS] = SERVIS, MARKA, MODELGRUP, MODEL, SASENO, S2a, S2b, S3, S3f, S4, S6, S7, S5_S7a, S8, S9, S10, S11, BO_FAALIYET ";
        }

        protected override List<string> GetVerbatimQuestions()
        {
                return new List<string>(new string[] { "S4", "S7", "S11", "BO_FAALIYET" });
        }

        protected override List<string> GetVerbatimOnlyQuestions()
        {
            return new List<string>(new string[] { "BO_FAALIYET" });
        }

        public override string DisplayName
        {
            get
            {
                return "Açık Uçlu Cevaplar";
            }
        }

        public override string SortPrefix
        {
            get { return "SSRD_02"; }
        }

        public override bool SupportsProject(string projectName)
        {
            return Context.CompatibleProjectName == Global.PROJECT_SSRD;
        }
    }
}
